Tabela Dictionary

Definicja tabeli Dictionary

Name

Dictionary

Code

Dictionary

Comment

 


Lista kolumn tabeli Dictionary

Name

Code

DictionaryID

DictionaryID

DictionaryTypeID

DictionaryTypeID

Active

Active

Code

Code

Description

Description

FullName

FullName

ShortName

ShortName

StartDT

StartDT

StopDT

StopDT


Kolumna DictionaryID tabeli Dictionary

Definicja kolumny DictionaryID tabeli Dictionary

Name

DictionaryID

Code

DictionaryID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DictionaryTypeID tabeli Dictionary

Definicja kolumny DictionaryTypeID tabeli Dictionary

Name

DictionaryTypeID

Code

DictionaryTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli Dictionary

Definicja kolumny Active tabeli Dictionary

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Code tabeli Dictionary

Definicja kolumny Code tabeli Dictionary

Name

Code

Code

Code

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna Description tabeli Dictionary

Definicja kolumny Description tabeli Dictionary

Name

Description

Code

Description

Data Type

VARCHAR2(768)

Mandatory

No

Comment

 


Kolumna FullName tabeli Dictionary

Definicja kolumny FullName tabeli Dictionary

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ShortName tabeli Dictionary

Definicja kolumny ShortName tabeli Dictionary

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(100)

Mandatory

No

Comment

 


Kolumna StartDT tabeli Dictionary

Definicja kolumny StartDT tabeli Dictionary

Name

StartDT

Code

StartDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StopDT tabeli Dictionary

Definicja kolumny StopDT tabeli Dictionary

Name

StopDT

Code

StopDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Lista kluczy tabeli Dictionary

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Dictionary

Definicja klucza Identifier_1 tabeli Dictionary

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment